This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
~Andy Frojumiettu 22.Jul.03 09:13 PM a Web browser General6.0.1Windows NT
Hi,
I have a shared database 25+ users, +- 5000 incomming mails a week, and I have a problem of the fulltext index getting corrupt almost everyday.
The server is generating the following Error messages:
Full Text message: Unexpected error. errcode = 6397
GTR search error for "D:\NOTESMAIL\help.ft\ftgi": Unexpected error. errcode = 6397: Full text index Corrupt, Try to Delete and Re-add Index
What I do everyday is, make the Database "out of service", disable replication, drop all users from that DB, and stop the router from the domino administrator.
Then I delete the index, run a fixup and a compact. That fixes the problem for about a day but then it gets corrupt within 24 hours again.
In this DB I have an agent that acts on incoming mail "after mail has arrived" which searches for keywords and then sets appropriate fields and/or moves the mail to another folder. There are about 10 subroutines of different searches of keywords in this agent, I thought maybe people could be trying to reply/move emails while the agent is acting on the emails, could this be the problem? (I do a call doc.save (False, False) in case someone is editing the email while the agent is acting on the mail)
What exactly causes a full text index to be corrupt, I would use the "rules" but In total I maybe have about 60 keywords to search for which would get really messy using rules.
Is there a way to do a keyword search without using the full text index? Ive looked on the help but could not find anyway other then using if (like XXXX) but you cant do that with the body of a mail because of rich text.